04/14/21 - 22:46

Dataset statistics

Number of variables	22
Number of observations	242559
Missing cells	1924222
Missing cells (%)	36.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	56.4 MiB
Average record size in memory	244.0 B

Variable types

NUM	12
UNSUPPORTED	7
CAT	2
BOOL	1

Warnings

`operation_car` has constant value "242559"	Constant
`operation_date` has a high cardinality: 25383 distinct values	High cardinality
`index_train` has 242559 (100.0%) missing values	Missing
`danger` has 223763 (92.3%) missing values	Missing
`loaded` has 242559 (100.0%) missing values	Missing
`operation_train` has 242559 (100.0%) missing values	Missing
`rod_train` has 242559 (100.0%) missing values	Missing
`ssp_station_esr` has 242559 (100.0%) missing values	Missing
`ssp_station_id` has 242559 (100.0%) missing values	Missing
`weight_brutto` has 242559 (100.0%) missing values	Missing
`adm` is highly skewed (γ1 = 26.46248648)	Skewed
`operation_st_id` is highly skewed (γ1 = 27.18052782)	Skewed
`df_index` has unique values	Unique
`index_train` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`loaded` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`operation_train` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`rod_train` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ssp_station_esr` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ssp_station_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`weight_brutto` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`receiver` has 55854 (23.0%) zeros	Zeros
`sender` has 33571 (13.8%) zeros	Zeros

Reproduction

Analysis started	2021-04-14 19:46:51.261742
Analysis finished	2021-04-14 19:47:48.078970
Duration	56.82 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	242559
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1941370.804
Minimum	5
Maximum	4189902
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	5
5-th percentile	199585.5
Q1	952495
median	1850939
Q3	2793773.5
95-th percentile	4029769.5
Maximum	4189902
Range	4189897
Interquartile range (IQR)	1841278.5

Descriptive statistics

Standard deviation	1166537.77
Coefficient of variation (CV)	0.6008835443
Kurtosis	-0.9912977725
Mean	1941370.804
Median Absolute Deviation (MAD)	919207
Skewness	0.2148600901
Sum	4.708969609e+11
Variance	1.360810368e+12
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3497996	1	< 0.1%
3871945	1	< 0.1%
2675889	1	< 0.1%
1098931	1	< 0.1%
3730614	1	< 0.1%
166444	1	< 0.1%
562361	1	< 0.1%
2655419	1	< 0.1%
2667709	1	< 0.1%
2141374	1	< 0.1%
2139327	1	< 0.1%
4093643	1	< 0.1%
228548	1	< 0.1%
1799365	1	< 0.1%
1772746	1	< 0.1%
3681454	1	< 0.1%
3343563	1	< 0.1%
438700	1	< 0.1%
3876047	1	< 0.1%
554842	1	< 0.1%
940776	1	< 0.1%
2358484	1	< 0.1%
152801	1	< 0.1%
3833060	1	< 0.1%
158950	1	< 0.1%
Other values (242534)	242534	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	1	< 0.1%
19	1	< 0.1%
22	1	< 0.1%
27	1	< 0.1%
35	1	< 0.1%
39	1	< 0.1%
50	1	< 0.1%
51	1	< 0.1%
52	1	< 0.1%
69	1	< 0.1%

Value	Count	Frequency (%)
4189902	1	< 0.1%
4189887	1	< 0.1%
4189884	1	< 0.1%
4189873	1	< 0.1%
4189871	1	< 0.1%
4189851	1	< 0.1%
4189849	1	< 0.1%
4189847	1	< 0.1%
4189845	1	< 0.1%
4189827	1	< 0.1%

index_train
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	242559
Missing (%)	100.0%
Memory size	1.9 MiB

length
Real number (ℝ_≥0)

Distinct	48
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.076795996
Minimum	0.79
Maximum	2.13
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	0.79
5-th percentile	0.87
Q1	1
median	1
Q3	1
95-th percentile	1.82
Maximum	2.13
Range	1.34
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.244850207
Coefficient of variation (CV)	0.227387739
Kurtosis	4.82369406
Mean	1.076795996
Median Absolute Deviation (MAD)	0
Skewness	2.478727108
Sum	261186.56
Variance	0.05995162384
Monotocity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
1	176254	72.7%
0.87	19218	7.9%
1.06	13818	5.7%
1.82	10636	4.4%
1.85	6341	2.6%
1.41	6166	2.5%
1.83	2758	1.1%
1.22	1045	0.4%
0.83	833	0.3%
1.36	829	0.3%
0.86	543	0.2%
1.11	416	0.2%
1.01	381	0.2%
0.79	360	0.1%
1.6	343	0.1%
1.89	336	0.1%
0.85	329	0.1%
1.27	262	0.1%
1.32	223	0.1%
1.23	193	0.1%
1.42	190	0.1%
1.05	165	0.1%
1.2	163	0.1%
1.35	158	0.1%
1.03	152	0.1%
Other values (23)	447	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.79	360	0.1%
0.83	833	0.3%
0.85	329	0.1%
0.86	543	0.2%
0.87	19218	7.9%
0.88	1	< 0.1%
0.9	1	< 0.1%
0.92	15	< 0.1%
0.95	21	< 0.1%
0.99	1	< 0.1%

Value	Count	Frequency (%)
2.13	46	< 0.1%
1.92	30	< 0.1%
1.89	336	0.1%
1.85	6341	2.6%
1.84	58	< 0.1%
1.83	2758	1.1%
1.82	10636	4.4%
1.81	1	< 0.1%
1.78	2	< 0.1%
1.77	17	< 0.1%

car_number
Real number (ℝ_≥0)

Distinct	201622
Distinct (%)	83.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	62898482.06
Minimum	24107542
Maximum	98099997
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	24107542
5-th percentile	51594265
Q1	54968421
median	60914074
Q3	63727609.5
95-th percentile	94654894
Maximum	98099997
Range	73992455
Interquartile range (IQR)	8759188.5

Descriptive statistics

Standard deviation	12807543.8
Coefficient of variation (CV)	0.2036224625
Kurtosis	2.051961618
Mean	62898482.06
Median Absolute Deviation (MAD)	4821314
Skewness	1.45274081
Sum	1.525659291e+13
Variance	1.640331783e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52480407	14	< 0.1%
64235385	13	< 0.1%
64939937	13	< 0.1%
63479570	13	< 0.1%
64903214	13	< 0.1%
52480969	13	< 0.1%
63514616	13	< 0.1%
62438056	12	< 0.1%
52480027	12	< 0.1%
54110176	12	< 0.1%
52480233	12	< 0.1%
62143649	12	< 0.1%
63310635	12	< 0.1%
63010144	12	< 0.1%
52480324	12	< 0.1%
55084396	11	< 0.1%
63642854	11	< 0.1%
63476006	11	< 0.1%
63373203	11	< 0.1%
62449905	11	< 0.1%
63423776	11	< 0.1%
63901888	11	< 0.1%
56184864	11	< 0.1%
54110028	11	< 0.1%
55084560	11	< 0.1%
Other values (201597)	242261	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
24107542	1	< 0.1%
24273559	1	< 0.1%
24293821	1	< 0.1%
24321838	1	< 0.1%
24345670	1	< 0.1%
24467441	1	< 0.1%
24576373	1	< 0.1%
24576506	1	< 0.1%
24590523	1	< 0.1%
24593485	1	< 0.1%

Value	Count	Frequency (%)
98099997	1	< 0.1%
98099989	1	< 0.1%
98099971	1	< 0.1%
98099963	1	< 0.1%
98099955	1	< 0.1%
98099948	1	< 0.1%
98099930	1	< 0.1%
98099922	1	< 0.1%
98099914	1	< 0.1%
98099906	1	< 0.1%

destination_esr
Real number (ℝ_≥0)

Distinct	1190
Distinct (%)	0.5%
Missing	2366
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%

Mean	699123.7066
Minimum	10002
Maximum	997502
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	10002
5-th percentile	35902
Q1	467004
median	864601
Q3	967808
95-th percentile	986103
Maximum	997502
Range	987500
Interquartile range (IQR)	500804

Descriptive statistics

Standard deviation	347089.5501
Coefficient of variation (CV)	0.4964637114
Kurtosis	-0.7118203195
Mean	699123.7066
Median Absolute Deviation (MAD)	117501
Skewness	-0.9848874575
Sum	1.679246205e+11
Variance	1.204711558e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
986103	21625	8.9%
76404	17779	7.3%
967808	16942	7.0%
864207	7784	3.2%
18502	5720	2.4%
947005	5601	2.3%
984700	4766	2.0%
864601	4280	1.8%
860206	3992	1.6%
592204	3853	1.6%
987801	3301	1.4%
985702	3283	1.4%
980200	2967	1.2%
937304	2926	1.2%
20706	2578	1.1%
989309	2499	1.0%
817600	2270	0.9%
60001	2256	0.9%
985505	2208	0.9%
191000	2123	0.9%
183502	2058	0.8%
467004	2005	0.8%
932207	1998	0.8%
924605	1965	0.8%
871906	1880	0.8%
Other values (1165)	111534	46.0%
(Missing)	2366	1.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10002	2	< 0.1%
10303	16	< 0.1%
11804	3	< 0.1%
13000	1	< 0.1%
14906	170	0.1%
15400	5	< 0.1%
15701	461	0.2%
16009	405	0.2%
16403	22	< 0.1%
17001	37	< 0.1%

Value	Count	Frequency (%)
997502	11	< 0.1%
994805	1	< 0.1%
993304	11	< 0.1%
991205	24	< 0.1%
991101	62	< 0.1%
990700	52	< 0.1%
990607	1	< 0.1%
990005	3	< 0.1%
989309	2499	1.0%
989205	1	< 0.1%

adm
Real number (ℝ_≥0)

SKEWED

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	20.04017167
Minimum	20
Maximum	99
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	20
5-th percentile	20
Q1	20
median	20
Q3	20
95-th percentile	20
Maximum	99
Range	79
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5198687065
Coefficient of variation (CV)	0.02594133
Kurtosis	2442.579832
Mean	20.04017167
Median Absolute Deviation (MAD)	0
Skewness	26.46248648
Sum	4860924
Variance	0.270263472
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
20	240847	99.3%
26	1318	0.5%
27	203	0.1%
21	157	0.1%
25	16	< 0.1%
24	14	< 0.1%
22	2	< 0.1%
99	1	< 0.1%
59	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20	240847	99.3%
21	157	0.1%
22	2	< 0.1%
24	14	< 0.1%
25	16	< 0.1%
26	1318	0.5%
27	203	0.1%
59	1	< 0.1%
99	1	< 0.1%

Value	Count	Frequency (%)
99	1	< 0.1%
59	1	< 0.1%
27	203	0.1%
26	1318	0.5%
25	16	< 0.1%
24	14	< 0.1%
22	2	< 0.1%
21	157	0.1%
20	240847	99.3%

danger
Boolean

MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	223763
Missing (%)	92.3%
Memory size	1.9 MiB

1	18796
(Missing)	223763

Common Values
Chart

Value	Count	Frequency (%)
1	18796	7.7%
(Missing)	223763	92.3%

gruz
Real number (ℝ_≥0)

Distinct	348
Distinct (%)	0.1%
Missing	60
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	163058.4186
Minimum	3009
Maximum	757325
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	3009
5-th percentile	3009
Q1	161043
median	161128
Q3	161170
95-th percentile	331016
Maximum	757325
Range	754316
Interquartile range (IQR)	127

Descriptive statistics

Standard deviation	91787.19135
Coefficient of variation (CV)	0.5629098584
Kurtosis	8.637154073
Mean	163058.4186
Median Absolute Deviation (MAD)	57
Skewness	1.649320022
Sum	3.954150346e+10
Variance	8424888496
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
161128	69691	28.7%
3009	28925	11.9%
161043	18983	7.8%
161185	14835	6.1%
161113	13762	5.7%
161170	10826	4.5%
161096	10512	4.3%
391498	6388	2.6%
141092	6185	2.5%
161147	6102	2.5%
214039	5632	2.3%
161016	4840	2.0%
161132	3998	1.6%
171030	3968	1.6%
211056	3223	1.3%
221066	2709	1.1%
91118	2125	0.9%
281048	1564	0.6%
161151	1450	0.6%
236038	1401	0.6%
81188	1335	0.6%
331016	1248	0.5%
151060	1236	0.5%
232431	1159	0.5%
161062	1103	0.5%
Other values (323)	19299	8.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3009	28925	11.9%
11005	223	0.1%
13000	2	< 0.1%
14003	17	< 0.1%
15006	13	< 0.1%
18023	74	< 0.1%
18108	13	< 0.1%
18112	1	< 0.1%
21079	1	< 0.1%
41123	3	< 0.1%

Value	Count	Frequency (%)
757325	2	< 0.1%
754115	1	< 0.1%
731062	3	< 0.1%
726079	1	< 0.1%
725502	150	0.1%
721484	321	0.1%
711459	33	< 0.1%
711444	19	< 0.1%
711285	7	< 0.1%
711035	26	< 0.1%

loaded
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	242559
Missing (%)	100.0%
Memory size	1.9 MiB

operation_car
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

10	242559

Value	Count	Frequency (%)
10	242559	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Overview of Unicode Properties

Unique unicode characters	3
Unique unicode categories	2 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	485118	50.0%
1	242559	25.0%
.	242559	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	727677	75.0%
Other Punctuation	242559	25.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	485118	66.7%
1	242559	33.3%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
.	242559	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	970236	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
0	485118	50.0%
1	242559	25.0%
.	242559	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	970236	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	485118	50.0%
1	242559	25.0%
.	242559	25.0%

operation_date
Categorical

HIGH CARDINALITY

Distinct	25383
Distinct (%)	10.5%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

2020-07-30 16:42:00	220
2020-07-18 16:52:00	195
2020-07-25 16:11:00	171
2020-07-29 16:54:00	171
2020-07-20 09:06:00	168
Other values (25378)	241634

Common Values
Overview

Value	Count	Frequency (%)
2020-07-30 16:42:00	220	0.1%
2020-07-18 16:52:00	195	0.1%
2020-07-25 16:11:00	171	0.1%
2020-07-29 16:54:00	171	0.1%
2020-07-20 09:06:00	168	0.1%
2020-07-16 16:43:00	165	0.1%
2020-07-23 16:38:00	163	0.1%
2020-07-25 17:07:00	159	0.1%
2020-07-31 18:24:00	159	0.1%
2020-07-17 17:30:00	157	0.1%
2020-07-20 16:10:00	157	0.1%
2020-07-22 08:39:00	153	0.1%
2020-07-17 16:58:00	153	0.1%
2020-07-16 15:08:00	153	0.1%
2020-07-30 16:19:00	150	0.1%
2020-07-29 16:56:00	150	0.1%
2020-07-29 16:59:00	149	0.1%
2020-07-28 16:51:00	147	0.1%
2020-07-17 15:10:00	145	0.1%
2020-07-30 16:47:00	145	0.1%
2020-07-18 10:20:00	144	0.1%
2020-07-19 17:07:00	143	0.1%
2020-07-23 13:37:00	143	0.1%
2020-07-22 08:32:00	141	0.1%
2020-07-23 16:19:00	139	0.1%
Other values (25358)	238619	98.4%

Frequencies of value counts

Unique

Unique	7954 ?
Unique (%)	3.3%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Overview of Unicode Properties

Unique unicode characters	13
Unique unicode categories	4 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	1417454	30.8%
2	723344	15.7%
-	485118	10.5%
:	485118	10.5%
1	342773	7.4%
7	325707	7.1%
	242559	5.3%
3	127467	2.8%
5	116137	2.5%
4	97703	2.1%
6	95118	2.1%
9	75153	1.6%
8	74970	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3395826	73.7%
Dash Punctuation	485118	10.5%
Other Punctuation	485118	10.5%
Space Separator	242559	5.3%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	1417454	41.7%
2	723344	21.3%
1	342773	10.1%
7	325707	9.6%
3	127467	3.8%
5	116137	3.4%
4	97703	2.9%
6	95118	2.8%
9	75153	2.2%
8	74970	2.2%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	485118	100.0%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	242559	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
:	485118	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4608621	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
0	1417454	30.8%
2	723344	15.7%
-	485118	10.5%
:	485118	10.5%
1	342773	7.4%
7	325707	7.1%
	242559	5.3%
3	127467	2.8%
5	116137	2.5%
4	97703	2.1%
6	95118	2.1%
9	75153	1.6%
8	74970	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4608621	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	1417454	30.8%
2	723344	15.7%
-	485118	10.5%
:	485118	10.5%
1	342773	7.4%
7	325707	7.1%
	242559	5.3%
3	127467	2.8%
5	116137	2.5%
4	97703	2.1%
6	95118	2.1%
9	75153	1.6%
8	74970	1.6%

operation_st_esr
Real number (ℝ_≥0)

Distinct	329
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	890745.2695
Minimum	831203
Maximum	998100
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	831203
5-th percentile	852708
Q1	863007
median	871906
Q3	924501
95-th percentile	980200
Maximum	998100
Range	166897
Interquartile range (IQR)	61494

Descriptive statistics

Standard deviation	38944.25544
Coefficient of variation (CV)	0.04372097925
Kurtosis	-0.04579097477
Mean	890745.2695
Median Absolute Deviation (MAD)	11903
Skewness	1.044461844
Sum	2.160582818e+11
Variance	1516655032
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
863007	20031	8.3%
937906	10887	4.5%
887603	9603	4.0%
887904	8850	3.6%
862201	7999	3.3%
864902	7904	3.3%
862108	7882	3.2%
932207	6178	2.5%
864705	5218	2.2%
864809	4895	2.0%
947005	4691	1.9%
980200	4215	1.7%
986103	4137	1.7%
871802	3905	1.6%
862606	3558	1.5%
872701	3495	1.4%
852708	3414	1.4%
871304	3314	1.4%
862305	3093	1.3%
831504	3093	1.3%
892103	2973	1.2%
863100	2969	1.2%
970406	2858	1.2%
863702	2831	1.2%
889007	2757	1.1%
Other values (304)	101809	42.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
831203	374	0.2%
831400	40	< 0.1%
831504	3093	1.3%
831608	3	< 0.1%
833603	4	< 0.1%
834108	1	< 0.1%
836103	3	< 0.1%
837303	1	< 0.1%
837604	8	< 0.1%
837708	64	< 0.1%

Value	Count	Frequency (%)
998100	5	< 0.1%
997502	1	< 0.1%
995403	56	< 0.1%
994805	6	< 0.1%
993304	9	< 0.1%
991101	4	< 0.1%
989309	199	0.1%
989205	118	< 0.1%
989008	8	< 0.1%
988804	7	< 0.1%

operation_st_id
Real number (ℝ_≥0)

SKEWED

Distinct	329
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2268180094
Minimum	2000035090
Maximum	2.000800023e+11
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	2000035090
5-th percentile	2000035530
Q1	2000037064
median	2001930776
Q3	2001931256
95-th percentile	2002025275
Maximum	2.000800023e+11
Range	1.980799672e+11
Interquartile range (IQR)	1894192

Descriptive statistics

Standard deviation	7267938794
Coefficient of variation (CV)	3.204304109
Kurtosis	736.7871799
Mean	2268180094
Median Absolute Deviation (MAD)	2746
Skewness	27.18052782
Sum	5.501674954e+14
Variance	5.282293432e+19
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2001933494	20031	8.3%
2000037532	10887	4.5%
2000035530	9603	4.0%
2000035564	8850	3.6%
2001930776	7999	3.3%
2000039908	7904	3.3%
2001930794	7882	3.2%
2000037064	6178	2.5%
2001933502	5218	2.2%
2001930822	4895	2.0%
2002025275	4691	1.9%
2002025607	4215	1.7%
2002025661	4137	1.7%
2001933522	3905	1.6%
2001930782	3558	1.5%
2001931256	3495	1.4%
2001930734	3414	1.4%
2001930872	3314	1.4%
2001930778	3093	1.3%
2001930534	3093	1.3%
2000035890	2973	1.2%
2001930798	2969	1.2%
2000038634	2858	1.2%
2001930812	2831	1.2%
2000035692	2757	1.1%
Other values (304)	101809	42.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2000035090	11	< 0.1%
2000035110	12	< 0.1%
2000035130	1	< 0.1%
2000035140	69	< 0.1%
2000035162	20	< 0.1%
2000035194	1525	0.6%
2000035216	1	< 0.1%
2000035230	126	0.1%
2000035232	616	0.3%
2000035252	1172	0.5%

Value	Count	Frequency (%)
2.000800023e+11	327	0.1%
2002034879	17	< 0.1%
2002026609	2	< 0.1%
2002025661	4137	1.7%
2002025613	77	< 0.1%
2002025611	627	0.3%
2002025609	675	0.3%
2002025607	4215	1.7%
2002025275	4691	1.9%
2002024829	88	< 0.1%

operation_train
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	242559
Missing (%)	100.0%
Memory size	1.9 MiB

receiver
Real number (ℝ_≥0)

ZEROS

Distinct	1819
Distinct (%)	0.8%
Missing	60
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	21249378.92
Minimum	0
Maximum	99294283
Zeros	55854
Zeros (%)	23.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	105199
median	1126648
Q3	39513543
95-th percentile	79601286
Maximum	99294283
Range	99294283
Interquartile range (IQR)	39408344

Descriptive statistics

Standard deviation	29510096.52
Coefficient of variation (CV)	1.388751014
Kurtosis	-0.05956922076
Mean	21249378.92
Median Absolute Deviation (MAD)	1126648
Skewness	1.164314481
Sum	5.152953139e+12
Variance	8.708457964e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	55854	23.0%
1126631	16339	6.7%
71479207	15444	6.4%
39513543	11879	4.9%
5757676	9371	3.9%
1125399	5720	2.4%
1126022	5479	2.3%
26635687	4281	1.8%
5757665	3899	1.6%
1126648	3301	1.4%
16397235	3004	1.2%
70639962	2578	1.1%
105638	2565	1.1%
43490931	2486	1.0%
26644096	2351	1.0%
79601286	2332	1.0%
1126016	2302	0.9%
73116035	2291	0.9%
186424	2236	0.9%
97728197	2148	0.9%
105199	1944	0.8%
31157965	1917	0.8%
160212	1863	0.8%
186683	1855	0.8%
98098048	1810	0.7%
Other values (1794)	77250	31.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	55854	23.0%
59625	9	< 0.1%
83262	455	0.2%
103094	1652	0.7%
105182	1030	0.4%
105199	1944	0.8%
105207	455	0.2%
105213	1194	0.5%
105236	1182	0.5%
105457	164	0.1%

Value	Count	Frequency (%)
99294283	5	< 0.1%
99149316	2	< 0.1%
98933686	25	< 0.1%
98770511	4	< 0.1%
98768158	2	< 0.1%
98288783	4	< 0.1%
98100331	1	< 0.1%
98098048	1810	0.7%
98061051	2	< 0.1%
97894760	6	< 0.1%

rodvag
Real number (ℝ_≥0)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	66.14466171
Minimum	20
Maximum	99
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	20
5-th percentile	60
Q1	60
median	60
Q3	60
95-th percentile	96
Maximum	99
Range	79
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	14.49677929
Coefficient of variation (CV)	0.2191677895
Kurtosis	1.309235417
Mean	66.14466171
Median Absolute Deviation (MAD)	0
Skewness	0.8915704381
Sum	16043983
Variance	210.1566098
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
60	176277	72.7%
96	35570	14.7%
70	18510	7.6%
90	4141	1.7%
20	3060	1.3%
40	2662	1.1%
93	1012	0.4%
95	542	0.2%
92	532	0.2%
87	252	0.1%
99	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20	3060	1.3%
40	2662	1.1%
60	176277	72.7%
70	18510	7.6%
87	252	0.1%
90	4141	1.7%
92	532	0.2%
93	1012	0.4%
95	542	0.2%
96	35570	14.7%

Value	Count	Frequency (%)
99	1	< 0.1%
96	35570	14.7%
95	542	0.2%
93	1012	0.4%
92	532	0.2%
90	4141	1.7%
87	252	0.1%
70	18510	7.6%
60	176277	72.7%
40	2662	1.1%

rod_train
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	242559
Missing (%)	100.0%
Memory size	1.9 MiB

sender
Real number (ℝ_≥0)

ZEROS

Distinct	878
Distinct (%)	0.4%
Missing	60
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	38753544.79
Minimum	0
Maximum	99863723
Zeros	33571
Zeros (%)	13.8%
Memory size	1.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10891709
median	26649063
Q3	68861216
95-th percentile	93149858
Maximum	99863723
Range	99863723
Interquartile range (IQR)	57969507

Descriptive statistics

Standard deviation	32066395.53
Coefficient of variation (CV)	0.8274441914
Kurtosis	-1.303849342
Mean	38753544.79
Median Absolute Deviation (MAD)	26488851
Skewness	0.3365886482
Sum	9.397695859e+12
Variance	1.028253723e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33571	13.8%
14788090	15974	6.6%
80298858	14538	6.0%
26635687	12968	5.3%
12776421	10788	4.4%
93149858	9105	3.8%
48134187	9097	3.8%
55472826	6417	2.6%
81195103	6404	2.6%
26644096	6353	2.6%
78465421	6090	2.5%
32214406	4857	2.0%
5757676	4846	2.0%
10891709	4619	1.9%
26648903	3778	1.6%
54998897	3485	1.4%
53067205	3467	1.4%
26648885	3179	1.3%
55565060	3032	1.3%
67680731	2898	1.2%
58146903	2853	1.2%
94421386	2732	1.1%
188110	2723	1.1%
53049555	2628	1.1%
98770511	2599	1.1%
Other values (853)	63498	26.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33571	13.8%
44474	146	0.1%
105207	1	< 0.1%
105457	9	< 0.1%
108708	1	< 0.1%
109783	2	< 0.1%
159953	7	< 0.1%
160206	75	< 0.1%
160212	1228	0.5%
161246	205	0.1%

Value	Count	Frequency (%)
99863723	8	< 0.1%
99415491	831	0.3%
99029960	19	< 0.1%
98770511	2599	1.1%
98113411	1	< 0.1%
98112127	15	< 0.1%
98108700	1	< 0.1%
98103401	1	< 0.1%
98098031	5	< 0.1%
97990972	7	< 0.1%

ssp_station_esr
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	242559
Missing (%)	100.0%
Memory size	1.9 MiB

ssp_station_id
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	242559
Missing (%)	100.0%
Memory size	1.9 MiB

tare_weight
Real number (ℝ_≥0)

Distinct	217
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	240.8990184
Minimum	2
Maximum	588
Zeros	0
Zeros (%)	0.0%
Memory size	1.9 MiB

Quantile statistics

Minimum	2
5-th percentile	220
Q1	235
median	240
Q3	246
95-th percentile	265
Maximum	588
Range	586
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	14.85898982
Coefficient of variation (CV)	0.06168140459
Kurtosis	31.37937321
Mean	240.8990184
Median Absolute Deviation (MAD)	5
Skewness	2.342966643
Sum	58432225
Variance	220.7895784
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
240	33104	13.6%
245	24998	10.3%
250	15644	6.4%
235	12138	5.0%
247	9899	4.1%
243	9256	3.8%
238	8889	3.7%
236	8396	3.5%
248	8124	3.3%
233	7514	3.1%
237	7148	2.9%
242	6485	2.7%
241	6363	2.6%
225	6086	2.5%
239	5671	2.3%
234	5354	2.2%
244	4700	1.9%
224	4679	1.9%
230	4201	1.7%
246	3722	1.5%
232	2951	1.2%
249	2908	1.2%
231	2163	0.9%
229	2147	0.9%
267	1830	0.8%
Other values (192)	38189	15.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
172	3	< 0.1%
173	2	< 0.1%
180	25	< 0.1%
181	8	< 0.1%
183	1	< 0.1%
184	1	< 0.1%
185	6	< 0.1%
186	1	< 0.1%
187	7	< 0.1%

Value	Count	Frequency (%)
588	2	< 0.1%
587	2	< 0.1%
586	2	< 0.1%
565	1	< 0.1%
524	1	< 0.1%
504	1	< 0.1%
475	2	< 0.1%
459	2	< 0.1%
458	4	< 0.1%
457	2	< 0.1%

weight_brutto
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	242559
Missing (%)	100.0%
Memory size	1.9 MiB

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	df_index	index_train	length	car_number	destination_esr	adm	danger	gruz	loaded	operation_car	operation_date	operation_st_esr	operation_st_id	operation_train	receiver	rodvag	rod_train	sender	ssp_station_esr	ssp_station_id	tare_weight	weight_brutto
0	5	NaN	1.0	62826326	460005.0	20.0	NaN	161170.0	NaN	10.0	2020-07-16 06:30:00	862409.0	2.001933e+09	NaN	0.0	60.0	NaN	14788090.0	NaN	NaN	241.0	NaN
1	19	NaN	1.0	62845078	18502.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 13:39:00	872701.0	2.001931e+09	NaN	1125399.0	60.0	NaN	80298858.0	NaN	NaN	245.0	NaN
2	22	NaN	1.0	62844568	986103.0	20.0	NaN	161147.0	NaN	10.0	2020-07-16 14:08:00	862803.0	2.001931e+09	NaN	1126631.0	60.0	NaN	14788090.0	NaN	NaN	245.0	NaN
3	27	NaN	1.0	62846316	592204.0	20.0	NaN	161043.0	NaN	10.0	2020-07-16 15:12:00	863702.0	2.001931e+09	NaN	5757665.0	60.0	NaN	32214406.0	NaN	NaN	249.0	NaN
4	35	NaN	1.0	62843222	986103.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 15:04:00	863007.0	2.001933e+09	NaN	1126631.0	60.0	NaN	14788090.0	NaN	NaN	245.0	NaN
5	39	NaN	1.0	62843115	986103.0	20.0	NaN	161185.0	NaN	10.0	2020-07-16 16:19:00	865604.0	2.001931e+09	NaN	1126631.0	60.0	NaN	14788090.0	NaN	NaN	245.0	NaN
6	50	NaN	1.0	62842943	986103.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 15:04:00	863007.0	2.001933e+09	NaN	1126631.0	60.0	NaN	14788090.0	NaN	NaN	245.0	NaN
7	51	NaN	1.0	62844311	76404.0	20.0	NaN	161113.0	NaN	10.0	2020-07-16 10:55:00	863007.0	2.001933e+09	NaN	39513543.0	60.0	NaN	26635687.0	NaN	NaN	245.0	NaN
8	52	NaN	1.0	62842778	986103.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 15:04:00	863007.0	2.001933e+09	NaN	1126631.0	60.0	NaN	14788090.0	NaN	NaN	245.0	NaN
9	69	NaN	1.0	62843347	18502.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 14:22:00	872701.0	2.001931e+09	NaN	1125399.0	60.0	NaN	80298858.0	NaN	NaN	245.0	NaN

Last rows

	df_index	index_train	length	car_number	destination_esr	adm	danger	gruz	loaded	operation_car	operation_date	operation_st_esr	operation_st_id	operation_train	receiver	rodvag	rod_train	sender	ssp_station_esr	ssp_station_id	tare_weight	weight_brutto
242549	4189827	NaN	1.0	62817580	970406.0	20.0	NaN	161170.0	NaN	10.0	2020-07-16 15:19:00	871802.0	2.001934e+09	NaN	98098048.0	60.0	NaN	93149858.0	NaN	NaN	249.0	NaN
242550	4189845	NaN	1.0	62818489	967808.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 16:04:00	862108.0	2.001931e+09	NaN	1126163.0	60.0	NaN	93149858.0	NaN	NaN	249.0	NaN
242551	4189847	NaN	1.0	62818125	967808.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 16:04:00	862108.0	2.001931e+09	NaN	1126163.0	60.0	NaN	93149858.0	NaN	NaN	249.0	NaN
242552	4189849	NaN	1.0	62818307	985702.0	20.0	NaN	161113.0	NaN	10.0	2020-07-16 14:38:00	863007.0	2.001933e+09	NaN	461379.0	60.0	NaN	27605317.0	NaN	NaN	248.0	NaN
242553	4189851	NaN	1.0	62817937	986103.0	20.0	NaN	161185.0	NaN	10.0	2020-07-16 06:03:00	864705.0	2.001934e+09	NaN	1126631.0	60.0	NaN	55472826.0	NaN	NaN	250.0	NaN
242554	4189871	NaN	1.0	62815741	76404.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 02:23:00	863007.0	2.001933e+09	NaN	39513543.0	60.0	NaN	54998897.0	NaN	NaN	249.0	NaN
242555	4189873	NaN	1.0	62815154	986103.0	20.0	NaN	161185.0	NaN	10.0	2020-07-16 06:03:00	864705.0	2.001934e+09	NaN	1126631.0	60.0	NaN	55472826.0	NaN	NaN	245.0	NaN
242556	4189884	NaN	1.0	62816756	967808.0	20.0	NaN	161128.0	NaN	10.0	2020-07-16 16:04:00	862108.0	2.001931e+09	NaN	1126163.0	60.0	NaN	93149858.0	NaN	NaN	250.0	NaN
242557	4189887	NaN	1.0	62816178	986103.0	20.0	NaN	161185.0	NaN	10.0	2020-07-16 06:03:00	864705.0	2.001934e+09	NaN	1126631.0	60.0	NaN	55472826.0	NaN	NaN	238.0	NaN
242558	4189902	NaN	1.0	62813852	592204.0	20.0	NaN	161043.0	NaN	10.0	2020-07-16 00:59:00	863100.0	2.001931e+09	NaN	5757665.0	60.0	NaN	43830663.0	NaN	NaN	247.0	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Dash Punctuation characters

Most frequent Space Separator characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows